using System;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel.DataAnnotations.Schema;

namespace Augustu.Models.WMS
{
    [Table("asn_detail")]
    public class AsnDetail : BaseModel
    {
[Column("Id")]
         public long  Id{ get; set;}

         /// <summary>
         /// 通知单明细编号
         /// </summary>
         [Comment("通知单明细编号")]
         [Column("asn_detail_no")]
         public string  AsnDetailNo{ get; set;} = string.Empty;

         /// <summary>
         /// 通知单id
         /// </summary>
         [Comment("通知单id")]
         [Column("asn_id")]
         public int  AsnId{ get; set;}

         /// <summary>
         /// 通知单编号
         /// </summary>
         [Comment("通知单编号")]
         [Column("asn_no")]
         public int  AsnNo{ get; set;}

         /// <summary>
         /// 通知单状态
         /// </summary>
         [Comment("通知单状态")]
         [Column("asn_status")]
         public int  AsnStatus{ get; set;}

         /// <summary>
         /// spu_id
         /// </summary>
         [Comment("spu_id")]
         [Column("spu_id")]
         public int  SpuId{ get; set;}

         /// <summary>
         /// sku_id
         /// </summary>
         [Comment("sku_id")]
         [Column("sku_id")]
         public int  SkuId{ get; set;}

         /// <summary>
         /// 通知单数量
         /// </summary>
         [Comment("通知单数量")]
         [Column("asn_qty")]
         public int  AsnQty{ get; set;}

         /// <summary>
         /// 实际数量
         /// </summary>
         [Comment("实际数量")]
         [Column("actual_qty")]
         public int  ActualQty{ get; set;}

         /// <summary>
         /// 到达时间
         /// </summary>
         [Comment("到达时间")]
         [Column("arrival_time")]
         public DateTime  ArrivalTime{ get; set;}

         /// <summary>
         /// 卸货时间
         /// </summary>
         [Comment("卸货时间")]
         [Column("unload_time")]
         public DateTime  UnloadTime{ get; set;}

         /// <summary>
         /// 卸货人id
         /// </summary>
         [Comment("卸货人id")]
         [Column("unload_person_id")]
         public long  UnloadPersonId{ get; set;}

         /// <summary>
         /// 已分拣数量
         /// </summary>
         [Comment("已分拣数量")]
         [Column("sorted_qty")]
         public int  SortedQty{ get; set;}

         /// <summary>
         /// 短缺的数量
         /// </summary>
         [Comment("短缺的数量")]
         [Column("shortage_qty")]
         public int  ShortageQty{ get; set;}

         /// <summary>
         /// 多发的数量
         /// </summary>
         [Comment("多发的数量")]
         [Column("excess_qty")]
         public int  ExcessQty{ get; set;}

         /// <summary>
         /// 损毁适量
         /// </summary>
         [Comment("损毁适量")]
         [Column("damage_qty")]
         public int  DamageQty{ get; set;}

         /// <summary>
         /// 重量
         /// </summary>
         [Comment("重量")]
         [Column("weight")]
         public decimal  Weight{ get; set;}

         /// <summary>
         /// 体积
         /// </summary>
         [Comment("体积")]
         [Column("volume")]
         public decimal  Volume{ get; set;}

         /// <summary>
         /// 供应商id
         /// </summary>
         [Comment("供应商id")]
         [Column("supplier_id")]
         public int  SupplierId{ get; set;}

         /// <summary>
         /// 采购单id
         /// </summary>
         [Comment("采购单id")]
         [Column("purchase_id")]
         public int  PurchaseId{ get; set;}

         /// <summary>
         /// 采购单明细id
         /// </summary>
         [Comment("采购单明细id")]
         [Column("purchase_detail_id")]
         public string  PurchaseDetailId{ get; set;} = string.Empty;
[Column("update_userId")]
         public string  UpdateUserid{ get; set;} = string.Empty;

    }
}
          
